-
Using WebHooks & API to create your own custom Column Functions
I thought it might be useful to share a general method I developed to add Functions missing from Smartsheet. This technique makes use of WebHooks & the API. Most important: users can add this to …4 · -
Re: Workflow Automation - Activate or Deactivate
Specifically, the AutomationRule Object has a boolean "enabled" attributed. https://smartsheet.redoc.ly/tag/automationRulesObjects#section/AutomationRule-Object There is also a "disabl…1 · -
Re: API call for RowID
The Smartsheet API search is rather limited. You can search to see if a string occurs in a row. You cannot limit the search to a specific column. If you can guarantee that your ID "PPRI - XXXX&q…1 · -
Re: Multiple IF Statements
You chain together additional conditions within the IF function. =IF([% Complete]2 = 0, "Not Started", IF([% Complete]2 = 1, "Complete", "In Progress")) In this case, I …2 · -
Re: Shortcut for nested IF function
You will want to do a VLOOKUP to another sheet that maintains these relationships of Product to Company. For example lets create a second sheet with two columns called "Product to Company" …1 ·
